package cn.ainit.sys.constant;

public class DzConstant {
	/*************************************
	 * mappingGroup  RunStype
	 * ***********************************/
	/***
	 * 数据源分组
	 */
	public final static String MAPPING_GROUP_EXCHANGE_GROUP = "select group_id id,group_name name from sys_exchange_group";
	/**
	 * 运行模式
	 */
	public final static String MAPPING_GROUP_RUN_MOD = "select code_value id,type_cname name,type_ename ename from sys_dz_edi_types where edi_type_id = 'mappingRunType'";
	/***
	 * 交换根项
	 */
	public final static String MAPPING_GROUP_EXCHANGE_ROOT_TABLES = "select GROUP_TABLE_ID,GROUP_ID,TABLE_NAME from sys_exchange_table WHERE SUPER_TABLE_ID = '' OR SUPER_TABLE_ID = 'null' OR SUPER_TABLE_ID IS NULL";
	/***
	 * 交换子项
	 */
	public final static String MAPPING_GROUP_EXCHANGE_TABLES = "select GROUP_TABLE_ID,GROUP_ID,SUPER_TABLE_ID,TABLE_NAME from SYS_EXCHANGE_TABLE WHERE SUPER_TABLE_ID != 'null' AND SUPER_TABLE_ID IS NOT NULL";
	
	
	public final static String MAPPING_GROUP_TARGET_EXCHNAGE_TABLE = ""; 
//	public final static String
//	public final static String
	
	
	
}
